Improving the Performance of SQL Join Operation in the Distributed Enterprise Information System by Caching

The enterprise information system (EIS) contains databases and other data sources in multiple data centers. Users query the EIS via clients. The client has a working space in the cloud. Caching data in client space will reduce the total execution time of the query. However, the client space has limited resources to store data. There are two options for caching data at the client space: caching the final results of query operations, or caching the source data tables. The problem is that some query operations such as “joining multiple big tables” will simply produce a result too big to store in cache in some cases. By contrast, caching source data tables may be a better choice in those situations. This paper presents an algorithm that combines active caching and passive caching to improve the cache hit, thus improving performance of the SQL join query in the cloud computing environment

ETL Pipeline Resource Predictions in Distributed Data Warehouses

Data warehouses of large corporations are increasing in size. Many companies have adopted a distributed data warehouse system， which may store data on many machines. Every day, millions of ETL jobs send data to those warehouses, but some jobs fail due to lack of resources and need to be restarted. Predicting ETL resource demands in distributed data warehouse systems is crucial for efficient use of resources and improved ETL pipeline tasks execution performance. The subject of resource-demand predictions for the ETL data pipeline has not yet been discussed in the literature. This paper discusses a method of predicting resource demands based on history. The linear regression function y = k x +b is used to predict memory, as well as disk usage, thus enabling improvement of accuracy of resource usage and the performance of ETL pipeline tasks execution

Improving the Data Warehouse Architecture Using Design Patterns

Data warehousing is an important part of the enterprise information system. Business intelligence (BI) relies on data warehouses to improve business performance. Data quality plays a key role in BI. Source data is extracted, transformed, and loaded (ETL) into the data warehouses periodically. The ETL operations have the most crucial impact on the data quality of the data warehouse. ETL-related data warehouse architectures including structure-oriented layer architectures and enterprise-view data mart architecture were studied in the literature. Existing architectures have the layer and data mart components but do not make use of design patterns; thus, those approaches are inefficient and pose potential problems. This paper relays how to use design patterns to improve data warehouse architectures

TsDAF-21/Hsp90 is expressed in all examined stages of Trichinella spiralis

Trichinella is an important parasitic nematode of animals worldwide. Heat shock proteins are ubiquitous in nature and allow organisms to quickly respond to environmental stress. A portion of the Tsdaf-21 gene, a Caenorhabditis elegans daf-21 homologue encoding heat-shock protein 90 (Hsp90) was cloned from Trichinella spiralis. The partial nucleotide sequence resided near the 5′-end of the gene and encoded a polypeptide of 254 amino acid residues harboring a HATPase-c superfamily domain and Hsp90 protein domain. Phylogenetic analysis revealed that Tsdaf-21 is highly conserved and formed a monophyletic clade with other nematodes. The partial Tsdaf-21 transcript was subcloned and expressed for antibody production. Results using PCR primers specific for the Tsdaf-21 transcript, and mouse polyclonal antisera specific for the recombinant protein showed that both the RNA transcript and the corresponding protein were ubiquitously and consistently expressed in newborn larvae, muscle larvae and both male and female adult worms in the absence of any external stress or stimulation

Building and implementing a multi-level system of ethical code for biologists under the Biological and Toxin Weapons Convention (BTWC) of the United Nations

The recent global COVID-19 pandemic has had profound economic and social impacts on the world. It has highlighted an urgent need to strengthen existing international biosecurity governance mechanisms to prevent the misuse and malicious abuse of life science research and maintain international biological arms control norms. Biologists are at the front line of biotechnology development and are key to maintaining biosecurity awareness and moral self-discipline. As an important first step, biologists need to actively participate in the formulation and implementation of relevant biosecurity policies and measures to ensure their effectiveness and sustainability. Furthermore, efforts should be made to advocate for and promote the establishment of an ethical code of conduct for biologists to share safety responsibilities for global biosecurity. To maximize the impact of this ethical code of conduct, an effective approach to implementing codes of conduct for biologists at both national and international levels should be established under the framework of the Biological and Toxin Weapons Convention (BTWC)